package com.hz.ruoyistorage.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.hz.ruoyistorage.domain.mypojo.StorageUser;
import org.apache.ibatis.annotations.Select;

import java.util.LinkedList;

/**
 * @version 1.0
 * @Author gj
 * @Date 2025/3/5 11:20
 * @注释
 */
public interface StorageUserMapper extends BaseMapper<StorageUser> {

    @Select("SELECT sys_user.user_id,sys_user.user_name FROM sys_user " +
            "LEFT JOIN sys_user_role ON sys_user.user_id = sys_user_role.user_id \n" +
            "LEFT JOIN sys_role ON sys_user_role.role_id = sys_role.role_id " +
            "WHERE sys_role.role_name = '冷库管理员';")
    public LinkedList<StorageUser> getStorageUserList();
}
